﻿<cfcomponent displayname="JustinsJobProg" output="false">

    <!--- Get Job Postings--->
    <cffunction name="funcGetJobPostings" returntype="query">
        <cfargument default="" name="PostingID" type="string" />
        
        <cfquery name="qryGetJobPostings" datasource="JustinsJobProg" >
            Select ID, Bulletin, JobTitle
            From joblistings
            <cfif ARGUMENTS.PostingID NEQ "">
                Where ID = <cfqueryparam cfsqltype="cf_sql_integer" value='#ARGUMENTS.PostingID#' />
            </cfif>
            Order By Jobtitle, Bulletin
        </cfquery>
        
        <cfreturn qryGetJobPostings />
    </cffunction>
    <!--- Get Job Postings--->
    
    
    
    
</cfcomponent>